﻿-- =============================================
-- Script Template
-- =============================================
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


/****Create Default Records ****/
PRINT 'INSERTING DEFAULT DATA .... [ContentTypeMaster]'
GO

SET IDENTITY_INSERT [ContentTypeMaster] ON
INSERT [ContentTypeMaster] ([ContentTypeKey], [ContentTypeCode], [ContentTypeName], [ContentDescription], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, N'BLG', N'BLOG', N'Blogs and Articles etc.', GETDATE(), GETDATE(), N'-1', N'-1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [ContentTypeMaster] ([ContentTypeKey], [ContentTypeCode], [ContentTypeName], [ContentDescription], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, N'DNL', N'DOWNLOADABLE', N'Downloadable Files and Resources', GETDATE(), GETDATE(), N'-1', N'-1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [ContentTypeMaster] ([ContentTypeKey], [ContentTypeCode], [ContentTypeName], [ContentDescription], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (3, N'VDO', N'VIDEO', N'Video and Webcasts', GETDATE(), GETDATE(), N'-1', N'-1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))
INSERT [ContentTypeMaster] ([ContentTypeKey], [ContentTypeCode], [ContentTypeName], [ContentDescription], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, N'AUD', N'AUDIO', N'Audio and Podcasts', GETDATE(), GETDATE(), N'-1', N'-1', 1, 0, -1, NULL, (SELECT @@SERVERNAME))

SET IDENTITY_INSERT [ContentTypeMaster] OFF